﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="view_list_room.aspx.cs" Inherits="view_list_rooom" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div align="center">
<br /><br /><br /><img src="Image/view-list-room.png" alt=""/>
    <br /><br />
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
        AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="ROOM_NO" 
        DataSourceID="orclDataSource2"
        ForeColor="#FFCC66" BorderColor="#4A1106" PageSize="20" 
        >
        <Columns>
            <asp:BoundField DataField="ROOM_NO" HeaderText="ROOM_NO" 
                SortExpression="ROOM_NO" ReadOnly="True" />
            <asp:BoundField DataField="ROOM_TYPE_NAME" HeaderText="ROOM_TYPE_NAME" 
                SortExpression="ROOM_TYPE_NAME" />
            <asp:BoundField DataField="PRICE" HeaderText="PRICE" 
                SortExpression="PRICE" />
            <asp:BoundField DataField="STATUS" HeaderText="STATUS" 
                SortExpression="STATUS" />
            <asp:BoundField DataField="GUEST_ID" HeaderText="GUEST_ID" 
                SortExpression="GUEST_ID" />
        </Columns>
        <HeaderStyle BackColor="#993300" />
        <PagerStyle HorizontalAlign="Center" />
        <RowStyle HorizontalAlign="Center" />
    </asp:GridView>

    <asp:SqlDataSource ID="orclDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString14 %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString14.ProviderName %>" SelectCommand="SELECT ROOMS.ROOM_NO, ROOM_DETAIL.ROOM_TYPE_NAME, ROOM_DETAIL.PRICE, ROOMS.STATUS, ROOMS.GUEST_ID FROM ROOMS INNER JOIN ROOM_DETAIL ON ROOMS.ROOM_TYPE_ID = ROOM_DETAIL.ROOM_TYPE_ID
ORDER BY ROOMS.ROOM_NO"></asp:SqlDataSource>

    <asp:SqlDataSource ID="orclDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString13 %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString13.ProviderName %>" 
        SelectCommand="SELECT ROOMS.ROOM_NO, ROOMS.STATUS, ROOMS.GUEST_ID, ROOM_DETAIL.ROOM_TYPE_NAME, GUEST_TYPE.GUEST_TYPE_NAME FROM GUESTS INNER JOIN ROOMS ON GUESTS.GUEST_ID = ROOMS.GUEST_ID INNER JOIN ROOM_DETAIL ON ROOMS.ROOM_TYPE_ID = ROOM_DETAIL.ROOM_TYPE_ID INNER JOIN GUEST_TYPE ON GUESTS.GUEST_TYPE_ID = GUEST_TYPE.GUEST_TYPE_ID">
    </asp:SqlDataSource>

        <br />
            <asp:Button ID="Button5" runat="server" BackColor="#FFCC66" 
                BorderColor="#FF9966" Height="25px" onclick="Back_Click" Text="&lt;&lt; Back" 
                Width="85px" />

</div>
</asp:Content>

